Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_SNAPSHOT

`DBA_HIST_SNAPSHOT` displays information about the snapshots in the Workload Repository.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SNAP_ID` | `NUMBER` | `NOT NULL` | Unique snapshot ID
`DBID` | `NUMBER` | `NOT NULL` | Database ID for the snapshot
`INSTANCE_NUMBER` | `NUMBER` | `NOT NULL` | Instance number for the snapshot
`STARTUP_TIME` | `TIMESTAMP(3)` | `NOT NULL` | Startup time of the instance
`BEGIN_INTERVAL_TIME` | `TIMESTAMP(3)` | `NOT NULL` | Time at the beginning of the snapshot interval
`END_INTERVAL_TIME` | `TIMESTAMP(3)` | `NOT NULL` | Time at the end of the snapshot interval; the actual time the snapshot was taken
`FLUSH_ELAPSED` | `INTERVAL DAY(5) TO SECOND(1)` |  | Amount of time to perform the snapshot
`SNAP_LEVEL` | `NUMBER` |  | Snapshot level
`ERROR_COUNT` | `NUMBER` |  | Number of errors occurring in the tables for the particular snapshot